Release 10.1A: OpenEdge Data Management:
DataServer for ORACLE

Modifying field-level information

At the field level, labels, descriptions, field triggers, and validation can be modified for each field in a table in the schema image.

To modify information in the schema image at the field level:

From the Data Dictionary main window, choose the Fields mode button.
Select a table from the Tables list.
Select a field from the Fields list.
Choose the Field Properties button. The following dialog box appears:



You can enter Progress information at the field level, such as a validation expression or a validation message. You can change the data type or the format in which Progress displays the data. For CHARACTER fields that are not indexed, you can change the case sensitivity. You cannot change a field definition to be an extent through the Data Dictionary.

Choose the DataServer button. The following dialog box provides information about the corresponding column in the ORACLE database:



Choose OK to return to the Field Properties dialog box.
When you are done making changes, choose OK to return to the Data Dictionary.
Note: You can override field-level validation expressions in your application by including the appropriate Progress 4GL statement.